UPDATE c1_role SET END_DATE = NOW(), DATA_STATE_CODE = '0' WHERE INSTR(:roleIds, ROLE_ID) > 0